Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

CLOSE STORED–PROCEDURE statement

For a non-Progress 4GL stored procedure, indicates that the procedure has completed execution and retrieves any return status. For a send–sql–statement stored procedure, closes the SQL cursor used by the procedure:

Syntax

CLOSE STORED-PROCEDURE procedure [ integer-field = PROC-STATUS ] [ WHERE PROC-HANDLE = integer-field ]

procedure

The name of the stored procedure that you want to close or the built-in procedure name, send–sql–statement.

integer–field = PROC–STATUS

Assigns the return value from a stored procedure to the specified integer field or variable (integer–field).

WHERE PROC–HANDLE = integer–field

An integer field or variable whose value uniquely identifies the stored procedure that produces the results returned from the data source or the SQL cursor of a send–sql–statement stored procedure.

Notes

If you specified a PROC–HANDLE when you ran a stored procedure, you must specify the PROC–HANDLE when you close the stored procedure.
If you do not specify a PROC–HANDLE, the CLOSE STORED–PROCEDURE statement closes the procedure if there is only one stored procedure running. If there is more than one stored procedure running, an error is returned.
You cannot close a send–sql–statement procedure until you have retrieved all row results.
You can close all stored procedures at once with the following statement:

RUN STORED-PROC closeallprocs.

See also

PROC–HANDLE function, PROC–STATUS function, RUN STORED–PROCEDURE statement